Model Data

Dataset statistics

Number of variables	25
Number of observations	213775
Missing cells	1313523
Missing cells (%)	24.6%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	163.9 MiB
Average record size in memory	803.7 B

Variable types

Numeric	9
Categorical	15
Boolean	1

Alerts

`AIRPORT_ID` has a high cardinality: 2465 distinct values	High cardinality
`LOCATION` has a high cardinality: 512 distinct values	High cardinality
`OPID` has a high cardinality: 585 distinct values	High cardinality
`RUNWAY` has a high cardinality: 808 distinct values	High cardinality
`STATE` has a high cardinality: 63 distinct values	High cardinality
`TIME` has a high cardinality: 1468 distinct values	High cardinality
`df_index` is highly correlated with `INCIDENT_YEAR`	High correlation
`DISTANCE` is highly correlated with `HEIGHT` and 1 other fields	High correlation
`HEIGHT` is highly correlated with `DISTANCE` and 1 other fields	High correlation
`INCIDENT_YEAR` is highly correlated with `df_index`	High correlation
`SPEED` is highly correlated with `DISTANCE` and 1 other fields	High correlation
`df_index` is highly correlated with `INCIDENT_YEAR`	High correlation
`DISTANCE` is highly correlated with `HEIGHT` and 1 other fields	High correlation
`HEIGHT` is highly correlated with `DISTANCE` and 1 other fields	High correlation
`INCIDENT_YEAR` is highly correlated with `df_index`	High correlation
`SPEED` is highly correlated with `DISTANCE` and 1 other fields	High correlation
`df_index` is highly correlated with `INCIDENT_YEAR`	High correlation
`DISTANCE` is highly correlated with `HEIGHT`	High correlation
`HEIGHT` is highly correlated with `DISTANCE` and 1 other fields	High correlation
`INCIDENT_YEAR` is highly correlated with `df_index`	High correlation
`SPEED` is highly correlated with `HEIGHT`	High correlation
`AC_CLASS` is highly correlated with `ENROUTE_STATE`	High correlation
`INDICATED_DAMAGE` is highly correlated with `ENROUTE_STATE`	High correlation
`PRECIPITATION` is highly correlated with `ENROUTE_STATE`	High correlation
`FAAREGION` is highly correlated with `STATE`	High correlation
`PHASE_OF_FLIGHT` is highly correlated with `ENROUTE_STATE`	High correlation
`TIME_OF_DAY` is highly correlated with `ENROUTE_STATE`	High correlation
`SKY` is highly correlated with `ENROUTE_STATE`	High correlation
`STATE` is highly correlated with `FAAREGION`	High correlation
`ENROUTE_STATE` is highly correlated with `AC_CLASS` and 6 other fields	High correlation
`AC_MASS` is highly correlated with `ENROUTE_STATE`	High correlation
`df_index` is highly correlated with `ENROUTE_STATE` and 1 other fields	High correlation
`DISTANCE` is highly correlated with `ENROUTE_STATE` and 3 other fields	High correlation
`ENROUTE_STATE` is highly correlated with `df_index` and 15 other fields	High correlation
`FAAREGION` is highly correlated with `ENROUTE_STATE` and 4 other fields	High correlation
`HEIGHT` is highly correlated with `DISTANCE` and 3 other fields	High correlation
`INCIDENT_MONTH` is highly correlated with `ENROUTE_STATE`	High correlation
`INCIDENT_YEAR` is highly correlated with `df_index` and 1 other fields	High correlation
`LATITUDE` is highly correlated with `ENROUTE_STATE` and 4 other fields	High correlation
`LONGITUDE` is highly correlated with `ENROUTE_STATE` and 4 other fields	High correlation
`PHASE_OF_FLIGHT` is highly correlated with `DISTANCE` and 3 other fields	High correlation
`PRECIPITATION` is highly correlated with `SKY`	High correlation
`SKY` is highly correlated with `PRECIPITATION`	High correlation
`SPEED` is highly correlated with `DISTANCE` and 4 other fields	High correlation
`STATE` is highly correlated with `ENROUTE_STATE` and 4 other fields	High correlation
`TIME_OF_DAY` is highly correlated with `ENROUTE_STATE`	High correlation
`WARNED` is highly correlated with `ENROUTE_STATE`	High correlation
`AC_MASS` is highly correlated with `ENROUTE_STATE` and 1 other fields	High correlation
`INDICATED_DAMAGE` is highly correlated with `ENROUTE_STATE`	High correlation
`c_score` is highly correlated with `ENROUTE_STATE` and 4 other fields	High correlation
`DISTANCE` has 59548 (27.9%) missing values	Missing
`ENROUTE_STATE` has 213769 (> 99.9%) missing values	Missing
`HEIGHT` has 87483 (40.9%) missing values	Missing
`LOCATION` has 213190 (99.7%) missing values	Missing
`PHASE_OF_FLIGHT` has 65371 (30.6%) missing values	Missing
`PRECIPITATION` has 103893 (48.6%) missing values	Missing
`RUNWAY` has 30089 (14.1%) missing values	Missing
`SKY` has 99952 (46.8%) missing values	Missing
`SPEED` has 133030 (62.2%) missing values	Missing
`TIME` has 98272 (46.0%) missing values	Missing
`TIME_OF_DAY` has 78080 (36.5%) missing values	Missing
`AC_CLASS` has 65249 (30.5%) missing values	Missing
`AC_MASS` has 65597 (30.7%) missing values	Missing
`LOCATION` is uniformly distributed	Uniform
`df_index` has unique values	Unique
`DISTANCE` has 137490 (64.3%) zeros	Zeros
`HEIGHT` has 54541 (25.5%) zeros	Zeros

Reproduction

Analysis started	2022-01-18 21:19:21.349045
Analysis finished	2022-01-18 21:20:16.260431
Duration	54.91 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

df_index
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIQUE

Distinct	213775
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	121333.1461

Minimum	0
Maximum	255908
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.6 MiB

Quantile statistics

Minimum	0
5-th percentile	11296.7
Q1	61636.5
median	120496
Q3	181928.5
95-th percentile	231086.3
Maximum	255908
Range	255908
Interquartile range (IQR)	120292

Descriptive statistics

Standard deviation	70272.93468
Coefficient of variation (CV)	0.5791734322
Kurtosis	-1.18210924
Mean	121333.1461
Median Absolute Deviation (MAD)	60173
Skewness	0.006462416908
Sum	2.593799331 × 10¹⁰
Variance	4938285348
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
161263	1	< 0.1%
161168	1	< 0.1%
161170	1	< 0.1%
161171	1	< 0.1%
161172	1	< 0.1%
161173	1	< 0.1%
161174	1	< 0.1%
161176	1	< 0.1%
161177	1	< 0.1%
Other values (213765)	213765	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
255908	1	< 0.1%
255907	1	< 0.1%
255906	1	< 0.1%
255840	1	< 0.1%
255758	1	< 0.1%
255756	1	< 0.1%
255755	1	< 0.1%
255754	1	< 0.1%
255421	1	< 0.1%
255417	1	< 0.1%

AIRPORT_ID
Categorical

HIGH CARDINALITY

Distinct	2465
Distinct (%)	1.2%
Missing	0
Missing (%)	0.0%
Memory size	12.4 MiB

KDEN	7786
KDFW	6752
KORD	5371
KJFK	4418
KMEM	4152
Other values (2460)	185296

Length

Max length	5
Median length	4
Mean length	3.996608584
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	837 ?
Unique (%)	0.4%

Sample

1st row	KMIE
2nd row	KMSY
3rd row	KORD
4th row	KMHT
5th row	KELP

Common Values

Value	Count	Frequency (%)
KDEN	7786	3.6%
KDFW	6752	3.2%
KORD	5371	2.5%
KJFK	4418	2.1%
KMEM	4152	1.9%
KSMF	3272	1.5%
KSLC	3223	1.5%
KMCO	3008	1.4%
KDTW	2962	1.4%
KLGA	2847	1.3%
Other values (2455)	169984	79.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
kden	7877	3.7%
kdfw	6752	3.2%
kord	5371	2.5%
kjfk	4418	2.1%
kmem	4152	1.9%
ksmf	3272	1.5%
kslc	3223	1.5%
kmco	3008	1.4%
kdtw	2962	1.4%
klga	2847	1.3%
Other values (2454)	169893	79.5%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

DISTANCE
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
ZEROS

Distinct	181
Distinct (%)	0.1%
Missing	59548
Missing (%)	27.9%
Infinite	0
Infinite (%)	0.0%
Mean	0.7795403204

Minimum	0
Maximum	99
Zeros	137490
Zeros (%)	64.3%
Negative	0
Negative (%)	0.0%
Memory size	1.6 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	5
Maximum	99
Range	99
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	3.532196689
Coefficient of variation (CV)	4.531127636
Kurtosis	90.67904576
Mean	0.7795403204
Median Absolute Deviation (MAD)	0
Skewness	7.804500252
Sum	120226.165
Variance	12.47641345
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	137490	64.3%
1	2295	1.1%
5	1931	0.9%
3	1613	0.8%
2	1584	0.7%
10	1425	0.7%
4	874	0.4%
15	803	0.4%
0.5	710	0.3%
20	673	0.3%
Other values (171)	4829	2.3%
(Missing)	59548	27.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	137490	64.3%
0.01	2	< 0.1%
0.05	2	< 0.1%
0.1	73	< 0.1%
0.125	4	< 0.1%
0.13	11	< 0.1%
0.15	1	< 0.1%
0.16	1	< 0.1%
0.2	133	0.1%
0.25	148	0.1%

Value	Count	Frequency (%)
99	3	< 0.1%
95	1	< 0.1%
90	2	< 0.1%
80	3	< 0.1%
75	6	< 0.1%
65	2	< 0.1%
62	1	< 0.1%
60	15	< 0.1%
55	3	< 0.1%
52	1	< 0.1%

ENROUTE_STATE
Categorical

HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	5
Distinct (%)	83.3%
Missing	213769
Missing (%)	> 99.9%
Memory size	6.5 MiB

RI	2
NY	1
GA	1
NJ	1
AB	1

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	66.7%

Sample

1st row	NY
2nd row	GA
3rd row	NJ
4th row	RI
5th row	RI

Common Values

Value	Count	Frequency (%)
RI	2	< 0.1%
NY	1	< 0.1%
GA	1	< 0.1%
NJ	1	< 0.1%
AB	1	< 0.1%
(Missing)	213769	> 99.9%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
ri	2	33.3%
ny	1	16.7%
ga	1	16.7%
nj	1	16.7%
ab	1	16.7%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

FAAREGION
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.2 MiB

ASO	43702
AEA	35181
AGL	33589
ASW	28227
AWP	27224
Other values (5)	45852

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	AGL
2nd row	ASW
3rd row	AGL
4th row	ANE
5th row	ASW

Common Values

Value	Count	Frequency (%)
ASO	43702	20.4%
AEA	35181	16.5%
AGL	33589	15.7%
ASW	28227	13.2%
AWP	27224	12.7%
ANM	21979	10.3%
ACE	10216	4.8%
ANE	7971	3.7%
FGN	4409	2.1%
AAL	1277	0.6%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
aso	43702	20.4%
aea	35181	16.5%
agl	33589	15.7%
asw	28227	13.2%
awp	27224	12.7%
anm	21979	10.3%
ace	10216	4.8%
ane	7971	3.7%
fgn	4409	2.1%
aal	1277	0.6%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

HEIGHT
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
ZEROS

Distinct	636
Distinct (%)	0.5%
Missing	87483
Missing (%)	40.9%
Infinite	0
Infinite (%)	0.0%
Mean	819.2182165

Minimum	0
Maximum	25000
Zeros	54541
Zeros (%)	25.5%
Negative	0
Negative (%)	0.0%
Memory size	1.6 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	30
Q3	700
95-th percentile	4500
Maximum	25000
Range	25000
Interquartile range (IQR)	700

Descriptive statistics

Standard deviation	1791.618142
Coefficient of variation (CV)	2.186985232
Kurtosis	17.16208504
Mean	819.2182165
Median Absolute Deviation (MAD)	30
Skewness	3.59538724
Sum	103460707
Variance	3209895.565
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	54541	25.5%
100	5781	2.7%
50	5196	2.4%
200	4414	2.1%
500	4266	2.0%
1000	3819	1.8%
10	3379	1.6%
300	3339	1.6%
3000	2789	1.3%
2000	2722	1.3%
Other values (626)	36046	16.9%
(Missing)	87483	40.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	54541	25.5%
1	134	0.1%
2	206	0.1%
3	175	0.1%
4	80	< 0.1%
5	1103	0.5%
6	41	< 0.1%
7	44	< 0.1%
8	68	< 0.1%
9	20	< 0.1%

Value	Count	Frequency (%)
25000	3	< 0.1%
24300	1	< 0.1%
24000	1	< 0.1%
23000	1	< 0.1%
22000	1	< 0.1%
21300	1	< 0.1%
21000	4	< 0.1%
20000	7	< 0.1%
19000	1	< 0.1%
18500	2	< 0.1%

INCIDENT_MONTH
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.216727868

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.6 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	5
median	8
Q3	9
95-th percentile	11
Maximum	12
Range	11
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.781289303
Coefficient of variation (CV)	0.3853947875
Kurtosis	-0.575629048
Mean	7.216727868
Median Absolute Deviation (MAD)	2
Skewness	-0.3823638586
Sum	1542756
Variance	7.735570187
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
8	31016	14.5%
7	28562	13.4%
9	28069	13.1%
10	25532	11.9%
5	19642	9.2%
6	18142	8.5%
11	14753	6.9%
4	14499	6.8%
3	10314	4.8%
12	8936	4.2%
Other values (2)	14310	6.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	7382	3.5%
2	6928	3.2%
3	10314	4.8%
4	14499	6.8%
5	19642	9.2%
6	18142	8.5%
7	28562	13.4%
8	31016	14.5%
9	28069	13.1%
10	25532	11.9%

Value	Count	Frequency (%)
12	8936	4.2%
11	14753	6.9%
10	25532	11.9%
9	28069	13.1%
8	31016	14.5%
7	28562	13.4%
6	18142	8.5%
5	19642	9.2%
4	14499	6.8%
3	10314	4.8%

INCIDENT_YEAR
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2009.814132

Minimum	1990
Maximum	2020
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.6 MiB

Quantile statistics

Minimum	1990
5-th percentile	1994
Q1	2005
median	2012
Q3	2016
95-th percentile	2019
Maximum	2020
Range	30
Interquartile range (IQR)	11

Descriptive statistics

Standard deviation	7.827250144
Coefficient of variation (CV)	0.003894514433
Kurtosis	-0.4634070087
Mean	2009.814132
Median Absolute Deviation (MAD)	5
Skewness	-0.6916566006
Sum	429648016
Variance	61.26584481
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
2019	14643	6.8%
2018	13966	6.5%
2017	12767	6.0%
2015	12045	5.6%
2014	11950	5.6%
2016	11758	5.5%
2020	10263	4.8%
2013	9950	4.7%
2012	9755	4.6%
2011	9213	4.3%
Other values (21)	97465	45.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1990	1702	0.8%
1991	2224	1.0%
1992	2437	1.1%
1993	2471	1.2%
1994	2501	1.2%
1995	2588	1.2%
1996	2742	1.3%
1997	3175	1.5%
1998	3551	1.7%
1999	4157	1.9%

Value	Count	Frequency (%)
2020	10263	4.8%
2019	14643	6.8%
2018	13966	6.5%
2017	12767	6.0%
2016	11758	5.5%
2015	12045	5.6%
2014	11950	5.6%
2013	9950	4.7%
2012	9755	4.6%
2011	9213	4.3%

LATITUDE
Real number (ℝ)

HIGH CORRELATION

Distinct	2458
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	36.90004351

Minimum	-37.673333
Maximum	71.28545
Zeros	0
Zeros (%)	0.0%
Negative	267
Negative (%)	0.1%
Memory size	1.6 MiB

Quantile statistics

Minimum	-37.673333
5-th percentile	26.07258
Q1	33.30783
median	38.81809
Q3	40.8501
95-th percentile	45.44906
Maximum	71.28545
Range	108.958783
Interquartile range (IQR)	7.54227

Descriptive statistics

Standard deviation	6.877066742
Coefficient of variation (CV)	0.1863701527
Kurtosis	10.71662481
Mean	36.90004351
Median Absolute Deviation (MAD)	3.425
Skewness	-1.535535012
Sum	7888306.802
Variance	47.29404697
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
39.85841	7786	3.6%
32.89595	6752	3.2%
41.9796	5371	2.5%
40.63975	4418	2.1%
35.04242	4152	1.9%
38.69542	3272	1.5%
40.78839	3223	1.5%
28.42889	3008	1.4%
42.21206	2962	1.4%
40.77724	2847	1.3%
Other values (2448)	169984	79.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-37.673333	1	< 0.1%
-37.008056	5	< 0.1%
-34.838417	12	< 0.1%
-34.822222	69	< 0.1%
-34.559175	2	< 0.1%
-33.964806	1	< 0.1%
-33.946111	9	< 0.1%
-33.392975	24	< 0.1%
-29.99383333	2	< 0.1%
-27.3833	1	< 0.1%

Value	Count	Frequency (%)
71.28545	15	< 0.1%
70.325	6	< 0.1%
70.20995	1	< 0.1%
70.19476	10	< 0.1%
69.3711127	1	< 0.1%
66.88468	34	< 0.1%
66.82853	1	< 0.1%
66.60013	1	< 0.1%
65.7586111	1	< 0.1%
65.69756	1	< 0.1%

LOCATION
Categorical

HIGH CARDINALITY
MISSING
UNIFORM

Distinct	512
Distinct (%)	87.5%
Missing	213190
Missing (%)	99.7%
Memory size	6.5 MiB

A	12
.	4
10 MI E	4
5 MI FINAL	4
5 MILES OUT	4
Other values (507)	557

Length

Max length	60
Median length	11
Mean length	11.01538462
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	474 ?
Unique (%)	81.0%

Sample

1st row	20 NE BNA
2nd row	30 NM EAST OAK
3rd row	50 MI E MCI
4th row	25 MI NW SUX
5th row	30 NW MIA

Common Values

Value	Count	Frequency (%)
A	12	< 0.1%
.	4	< 0.1%
10 MI E	4	< 0.1%
5 MI FINAL	4	< 0.1%
5 MILES OUT	4	< 0.1%
3 MI FINAL	4	< 0.1%
15 NW	4	< 0.1%
5 MI W	4	< 0.1%
SBN-MEM	4	< 0.1%
10 MI FINAL	4	< 0.1%
Other values (502)	537	0.3%
(Missing)	213190	99.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
mi	249	12.4%
nm	80	4.0%
of	67	3.4%
10	66	3.3%
5	59	2.9%
n	51	2.5%
e	49	2.5%
w	48	2.4%
miles	46	2.3%
15	46	2.3%
Other values (373)	1239	62.0%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

LONGITUDE
Real number (ℝ)

HIGH CORRELATION

Distinct	2460
Distinct (%)	1.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-91.66612381

Minimum	-177.381
Maximum	178.559228
Zeros	0
Zeros (%)	0.0%
Negative	211819
Negative (%)	99.1%
Memory size	1.6 MiB

Quantile statistics

Minimum	-177.381
5-th percentile	-122.37484
Q1	-100.49631
median	-87.90446
Q3	-80.29056
95-th percentile	-72.8871
Maximum	178.559228
Range	355.940228
Interquartile range (IQR)	20.20575

Descriptive statistics

Standard deviation	25.16118536
Coefficient of variation (CV)	-0.274487284
Kurtosis	28.86807481
Mean	-91.66612381
Median Absolute Deviation (MAD)	9.13274
Skewness	3.039541983
Sum	-19595925.62
Variance	633.0852489
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-104.667	7786	3.6%
-97.0372	6752	3.2%
-87.90446	5371	2.5%
-73.77893	4418	2.1%
-89.97667	4152	1.9%
-121.59077	3272	1.5%
-111.97777	3223	1.5%
-81.31603	3008	1.4%
-83.34884	2962	1.4%
-73.87261	2847	1.3%
Other values (2450)	169984	79.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-177.381	74	< 0.1%
-176.6460306	2	< 0.1%
-171.7327778	1	< 0.1%
-170.71053	45	< 0.1%
-170.2225556	1	< 0.1%
-169.6637361	2	< 0.1%
-169.5345	5	< 0.1%
-168.9530556	1	< 0.1%
-166.5435	26	< 0.1%
-165.6041083	1	< 0.1%

Value	Count	Frequency (%)
178.559228	1	< 0.1%
177.443378	1	< 0.1%
174.791667	5	< 0.1%
174.11333	2	< 0.1%
171.27203	9	< 0.1%
167.4333	2	< 0.1%
166.63666	1	< 0.1%
158.208989	21	< 0.1%
153.11833	1	< 0.1%
151.177222	9	< 0.1%

OPID
Categorical

HIGH CARDINALITY

Distinct	585
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	12.2 MiB

UNK	64856
BUS	17670
SWA	17345
AAL	14069
UAL	10532
Other values (580)	89303

Length

Max length	5
Median length	3
Mean length	3.023688457
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	98 ?
Unique (%)	< 0.1%

Sample

1st row	PVT
2nd row	TWA
3rd row	UAL
4th row	PVT
5th row	AAL

Common Values

Value	Count	Frequency (%)
UNK	64856	30.3%
BUS	17670	8.3%
SWA	17345	8.1%
AAL	14069	6.6%
UAL	10532	4.9%
DAL	8865	4.1%
FDX	8011	3.7%
SKW	4731	2.2%
UPS	4527	2.1%
USA	3775	1.8%
Other values (575)	59394	27.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
unk	64856	30.3%
bus	17670	8.3%
swa	17345	8.1%
aal	14069	6.6%
ual	10532	4.9%
dal	8865	4.1%
fdx	8011	3.7%
skw	4731	2.2%
ups	4527	2.1%
usa	3775	1.8%
Other values (572)	59394	27.8%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

PHASE_OF_FLIGHT
Categorical

HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	11
Distinct (%)	< 0.1%
Missing	65371
Missing (%)	30.6%
Memory size	11.3 MiB

Approach	64585
Landing Roll	27459
Take-off Run	26340
Climb	24041
Descent	1974
Other values (6)	4005

Length

Max length	12
Median length	8
Mean length	8.927609768
Min length	4

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Approach
2nd row	Landing Roll
3rd row	Landing Roll
4th row	Approach
5th row	Approach

Common Values

Value	Count	Frequency (%)
Approach	64585	30.2%
Landing Roll	27459	12.8%
Take-off Run	26340	12.3%
Climb	24041	11.2%
Descent	1974	0.9%
Departure	1957	0.9%
Local	802	0.4%
Arrival	601	0.3%
Taxi	554	0.3%
Parked	81	< 0.1%
(Missing)	65371	30.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
approach	64585	31.9%
landing	27459	13.6%
roll	27459	13.6%
take-off	26340	13.0%
run	26340	13.0%
climb	24041	11.9%
descent	1974	1.0%
departure	1957	1.0%
local	802	0.4%
arrival	601	0.3%
Other values (3)	645	0.3%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

PRECIPITATION
Categorical

HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	11
Distinct (%)	< 0.1%
Missing	103893
Missing (%)	48.6%
Memory size	9.6 MiB

None	100181
Rain	6700
Fog	2279
Snow	396
Fog, Rain	269
Other values (6)	57

Length

Max length	15
Median length	4
Mean length	3.994667006
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	None
2nd row	None
3rd row	None
4th row	None
5th row	None

Common Values

Value	Count	Frequency (%)
None	100181	46.9%
Rain	6700	3.1%
Fog	2279	1.1%
Snow	396	0.2%
Fog, Rain	269	0.1%
Rain, Snow	20	< 0.1%
Fog, Snow	14	< 0.1%
None, Snow	10	< 0.1%
Fog, Rain, Snow	5	< 0.1%
Fog, None	5	< 0.1%
(Missing)	103893	48.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
none	100199	90.9%
rain	6997	6.3%
fog	2572	2.3%
snow	445	0.4%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

RUNWAY
Categorical

HIGH CARDINALITY
MISSING

Distinct	808
Distinct (%)	0.4%
Missing	30089
Missing (%)	14.1%
Memory size	11.4 MiB

17R	3515
27	3422
22L	3215
23	3178
16R	3166
Other values (803)	167190

Length

Max length	31
Median length	3
Mean length	2.626248054
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	396 ?
Unique (%)	0.2%

Sample

1st row	1
2nd row	22R
3rd row	35
4th row	26L
5th row	24R

Common Values

Value	Count	Frequency (%)
17R	3515	1.6%
27	3422	1.6%
22L	3215	1.5%
23	3178	1.5%
16R	3166	1.5%
22	3165	1.5%
17L	3117	1.5%
31	3088	1.4%
4R	3051	1.4%
24	2854	1.3%
Other values (798)	151915	71.1%
(Missing)	30089	14.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
17r	3529	1.9%
27	3422	1.9%
22l	3227	1.7%
23	3178	1.7%
16r	3176	1.7%
22	3166	1.7%
17l	3124	1.7%
31	3090	1.7%
4r	3057	1.7%
24	2856	1.5%
Other values (608)	152773	82.8%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

SKY
Categorical

HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	3
Distinct (%)	< 0.1%
Missing	99952
Missing (%)	46.8%
Memory size	10.2 MiB

No Cloud	54187
Some Cloud	39354
Overcast	20282

Length

Max length	10
Median length	8
Mean length	8.691494689
Min length	8

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	No Cloud
2nd row	No Cloud
3rd row	No Cloud
4th row	No Cloud
5th row	No Cloud

Common Values

Value	Count	Frequency (%)
No Cloud	54187	25.3%
Some Cloud	39354	18.4%
Overcast	20282	9.5%
(Missing)	99952	46.8%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
cloud	93541	45.1%
no	54187	26.1%
some	39354	19.0%
overcast	20282	9.8%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

SPEED
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	277
Distinct (%)	0.3%
Missing	133030
Missing (%)	62.2%
Infinite	0
Infinite (%)	0.0%
Mean	143.0360518

Minimum	0
Maximum	400
Zeros	15
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.6 MiB

Quantile statistics

Minimum	0
5-th percentile	75
Q1	120
median	140
Q3	160
95-th percentile	250
Maximum	400
Range	400
Interquartile range (IQR)	40

Descriptive statistics

Standard deviation	46.09679136
Coefficient of variation (CV)	0.3222739358
Kurtosis	0.8132594206
Mean	143.0360518
Median Absolute Deviation (MAD)	20
Skewness	0.6118044344
Sum	11549446
Variance	2124.914174
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
140	9082	4.2%
130	6432	3.0%
120	5717	2.7%
150	5483	2.6%
100	5009	2.3%
135	4115	1.9%
250	3601	1.7%
160	3421	1.6%
180	2998	1.4%
110	2636	1.2%
Other values (267)	32251	15.1%
(Missing)	133030	62.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	15	< 0.1%
1	1	< 0.1%
2	4	< 0.1%
3	5	< 0.1%
4	4	< 0.1%
5	38	< 0.1%
6	1	< 0.1%
7	2	< 0.1%
8	3	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
400	2	< 0.1%
380	1	< 0.1%
374	1	< 0.1%
365	1	< 0.1%
363	1	< 0.1%
355	2	< 0.1%
354	1	< 0.1%
350	8	< 0.1%
340	5	< 0.1%
335	1	< 0.1%

STATE
Categorical

HIGH CARDINALITY
HIGH CORRELATION
HIGH CORRELATION

Distinct	63
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.0 MiB

TX	20780
CA	17846
FL	16600
NY	11751
IL	10231
Other values (58)	136567

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	IN
2nd row	LA
3rd row	IL
4th row	NH
5th row	TX

Common Values

Value	Count	Frequency (%)
TX	20780	9.7%
CA	17846	8.3%
FL	16600	7.8%
NY	11751	5.5%
IL	10231	4.8%
CO	9952	4.7%
PA	7280	3.4%
TN	7062	3.3%
OH	6983	3.3%
NJ	6493	3.0%
Other values (53)	98797	46.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
tx	20780	9.7%
ca	17846	8.3%
fl	16600	7.8%
ny	11751	5.5%
il	10231	4.8%
co	9952	4.7%
pa	7280	3.4%
tn	7062	3.3%
oh	6983	3.3%
nj	6493	3.0%
Other values (53)	98797	46.2%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

TIME
Categorical

HIGH CARDINALITY
MISSING

Distinct	1468
Distinct (%)	1.3%
Missing	98272
Missing (%)	46.0%
Memory size	9.8 MiB

09:00	1084
08:00	1042
10:00	1005
11:00	847
08:30	836
Other values (1463)	110689

Length

Max length	6
Median length	5
Mean length	4.999930738
Min length	4

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	23 ?
Unique (%)	< 0.1%

Sample

1st row	19:05
2nd row	08:08
3rd row	08:10
4th row	18:00
5th row	20:25

Common Values

Value	Count	Frequency (%)
09:00	1084	0.5%
08:00	1042	0.5%
10:00	1005	0.5%
11:00	847	0.4%
08:30	836	0.4%
22:00	830	0.4%
09:30	821	0.4%
21:00	811	0.4%
07:00	807	0.4%
23:00	784	0.4%
Other values (1458)	106636	49.9%
(Missing)	98272	46.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
09:00	1084	0.9%
08:00	1042	0.9%
10:00	1005	0.9%
11:00	847	0.7%
08:30	836	0.7%
22:00	830	0.7%
09:30	821	0.7%
21:00	811	0.7%
07:00	807	0.7%
23:00	784	0.7%
Other values (1453)	106636	92.3%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

TIME_OF_DAY
Categorical

HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	4
Distinct (%)	< 0.1%
Missing	78080
Missing (%)	36.5%
Memory size	10.2 MiB

Day	84523
Night	39874
Dusk	6250
Dawn	5048

Length

Max length	5
Median length	3
Mean length	3.67096061
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Night
2nd row	Day
3rd row	Day
4th row	Night
5th row	Night

Common Values

Value	Count	Frequency (%)
Day	84523	39.5%
Night	39874	18.7%
Dusk	6250	2.9%
Dawn	5048	2.4%
(Missing)	78080	36.5%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
day	84523	62.3%
night	39874	29.4%
dusk	6250	4.6%
dawn	5048	3.7%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

WARNED
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.6 MiB

Unknown	119844
No	52850
Yes	41081

Length

Max length	7
Median length	7
Mean length	4.995209917
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	No
2nd row	Unknown
3rd row	Unknown
4th row	No
5th row	No

Common Values

Value	Count	Frequency (%)
Unknown	119844	56.1%
No	52850	24.7%
Yes	41081	19.2%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
unknown	119844	56.1%
no	52850	24.7%
yes	41081	19.2%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

AC_CLASS
Categorical

HIGH CORRELATION
MISSING

Distinct	5
Distinct (%)	< 0.1%
Missing	65249
Missing (%)	30.5%
Memory size	10.2 MiB

A	147725
B	792
J	4
C	4
Y	1

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	A
2nd row	A
3rd row	A
4th row	A
5th row	A

Common Values

Value	Count	Frequency (%)
A	147725	69.1%
B	792	0.4%
J	4	< 0.1%
C	4	< 0.1%
Y	1	< 0.1%
(Missing)	65249	30.5%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
a	147725	99.5%
b	792	0.5%
j	4	< 0.1%
c	4	< 0.1%
y	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

AC_MASS
Categorical

HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	5
Distinct (%)	< 0.1%
Missing	65597
Missing (%)	30.7%
Memory size	11.0 MiB

4.0	100564
3.0	27924
1.0	9439
2.0	8604
5.0	1647

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	4.0
3rd row	4.0
4th row	1.0
5th row	4.0

Common Values

Value	Count	Frequency (%)
4.0	100564	47.0%
3.0	27924	13.1%
1.0	9439	4.4%
2.0	8604	4.0%
5.0	1647	0.8%
(Missing)	65597	30.7%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
4.0	100564	67.9%
3.0	27924	18.8%
1.0	9439	6.4%
2.0	8604	5.8%
5.0	1647	1.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

INDICATED_DAMAGE
Boolean

HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	208.9 KiB

False	199475
True	14300

Common Values
Chart

Value	Count	Frequency (%)
False	199475	93.3%
True	14300	6.7%

c_score
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	47
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.0783049

Minimum	0.03
Maximum	9.17
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.6 MiB

Quantile statistics

Minimum	0.03
5-th percentile	0.72
Q1	2.58
median	3.29
Q3	4.54
95-th percentile	9.17
Maximum	9.17
Range	9.14
Interquartile range (IQR)	1.96

Descriptive statistics

Standard deviation	2.422975187
Coefficient of variation (CV)	0.5941133012
Kurtosis	-0.3346380145
Mean	4.0783049
Median Absolute Deviation (MAD)	1.12
Skewness	0.7533522629
Sum	871839.63
Variance	5.870808759
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
9.17	19177	9.0%
7.28	12796	6.0%
4.32	12208	5.7%
4.54	11372	5.3%
7.58	10491	4.9%
2.58	10415	4.9%
3.99	10079	4.7%
3.51	9776	4.6%
6.22	9682	4.5%
2.95	9586	4.5%
Other values (37)	98193	45.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.03	234	0.1%
0.04	286	0.1%
0.05	188	0.1%
0.08	106	< 0.1%
0.09	110	0.1%
0.11	355	0.2%
0.12	124	0.1%
0.13	185	0.1%
0.17	153	0.1%
0.18	507	0.2%

Value	Count	Frequency (%)
9.17	19177	9.0%
7.58	10491	4.9%
7.28	12796	6.0%
6.22	9682	4.5%
4.54	11372	5.3%
4.32	12208	5.7%
3.99	10079	4.7%
3.97	8535	4.0%
3.51	9776	4.6%
3.29	6162	2.9%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	df_index	AIRPORT_ID	DISTANCE	ENROUTE_STATE	FAAREGION	HEIGHT	INCIDENT_MONTH	INCIDENT_YEAR	LATITUDE	LOCATION	LONGITUDE	OPID	PHASE_OF_FLIGHT	PRECIPITATION	RUNWAY	SKY	SPEED	STATE	TIME	TIME_OF_DAY	WARNED	AC_CLASS	AC_MASS	INDICATED_DAMAGE	c_score
0	0	KMIE	NaN	NaN	AGL	200.0	10	1990	40.24235	NaN	-85.39586	PVT	Approach	None	NaN	No Cloud	70.0	IN	NaN	Night	No	A	1.0	False	2.95
1	1	KMSY	0.0	NaN	ASW	0.0	8	1993	29.99339	NaN	-90.25803	TWA	Landing Roll	NaN	1	NaN	NaN	LA	NaN	Day	Unknown	A	4.0	False	2.08
2	2	KORD	0.0	NaN	AGL	0.0	8	1996	41.97960	NaN	-87.90446	UAL	Landing Roll	NaN	22R	NaN	NaN	IL	NaN	NaN	Unknown	A	4.0	False	4.54
3	3	KMHT	8.0	NaN	ANE	1800.0	9	1993	42.93452	NaN	-71.43706	PVT	Approach	None	35	No Cloud	150.0	NH	NaN	Day	No	A	1.0	True	3.09
4	4	KELP	NaN	NaN	ASW	200.0	3	1991	31.80667	NaN	-106.37781	AAL	Approach	None	26L	No Cloud	135.0	TX	NaN	Night	No	A	4.0	False	0.72
5	5	KPDX	NaN	NaN	ANM	300.0	10	1990	45.58872	NaN	-122.59750	AAL	Approach	None	NaN	No Cloud	140.0	OR	NaN	Night	No	A	4.0	False	3.29
6	7	KLAX	9.0	NaN	AWP	4000.0	4	1995	33.94254	NaN	-118.40807	UAL	Approach	NaN	24R	NaN	NaN	CA	NaN	NaN	Unknown	A	4.0	False	3.97
7	8	KSAT	0.0	NaN	ASW	0.0	8	1991	29.53369	NaN	-98.46978	SWA	Landing Roll	None	NaN	No Cloud	120.0	TX	NaN	Day	No	A	4.0	False	3.51
8	9	KSAT	NaN	NaN	ASW	1500.0	4	1991	29.53369	NaN	-98.46978	AAL	Approach	None	NaN	Overcast	170.0	TX	NaN	Night	No	A	4.0	False	3.51
9	10	KBUR	NaN	NaN	AWP	800.0	5	1990	34.20062	NaN	-118.35850	1AWE	Approach	None	NaN	No Cloud	120.0	CA	NaN	Day	Yes	A	4.0	False	3.97

Last rows

	df_index	AIRPORT_ID	DISTANCE	ENROUTE_STATE	FAAREGION	HEIGHT	INCIDENT_MONTH	INCIDENT_YEAR	LATITUDE	LOCATION	LONGITUDE	OPID	PHASE_OF_FLIGHT	PRECIPITATION	RUNWAY	SKY	SPEED	STATE	TIME	TIME_OF_DAY	WARNED	AC_CLASS	AC_MASS	INDICATED_DAMAGE	c_score
213765	255417	W91	0.0	NaN	AEA	0.0	12	2009	37.104500	NaN	-79.588700	PVT	Landing Roll	NaN	NaN	NaN	NaN	VA	NaN	NaN	Unknown	A	1.0	True	3.25
213766	255421	KCDW	0.0	NaN	AEA	0.0	3	2012	40.875220	NaN	-74.281360	PVT	Landing Roll	NaN	4	NaN	NaN	NJ	23:25	Night	Unknown	A	1.0	True	9.17
213767	255754	KJAX	0.0	NaN	ASO	NaN	2	2020	30.494060	NaN	-81.687860	RPA	Climb	NaN	8	NaN	NaN	FL	NaN	NaN	Unknown	A	4.0	False	1.14
213768	255755	57C	0.0	NaN	AGL	0.0	1	2015	42.797167	NaN	-88.372611	BUS	Landing Roll	NaN	26	NaN	NaN	WI	19:07	Night	Unknown	A	1.0	True	4.54
213769	255756	KFWS	1.0	NaN	ASW	NaN	6	2020	32.565228	NaN	-97.308078	PVT	Approach	NaN	17R	NaN	NaN	TX	12:13	Day	Unknown	A	1.0	True	4.32
213770	255758	50D	0.0	NaN	AGL	0.0	6	2017	46.009080	NaN	-88.274026	PVT	Landing Roll	NaN	30	NaN	NaN	MI	10:50	Day	Unknown	A	1.0	True	1.01
213771	255840	KFSD	0.0	NaN	AGL	100.0	2	2020	43.581350	NaN	-96.741700	LOF	Climb	None	21	Overcast	NaN	SD	18:35	Dusk	Unknown	A	3.0	True	1.34
213772	255906	KLAX	NaN	NaN	AWP	100.0	8	2009	33.942540	NaN	-118.408070	SHQ	Climb	None	25R	No Cloud	190.0	CA	14:48	Day	Unknown	A	4.0	True	3.97
213773	255907	KPMD	NaN	NaN	AWP	NaN	12	2020	34.629390	NaN	-118.084550	BOE	Departure	NaN	NaN	NaN	NaN	CA	12:20	Day	Unknown	A	4.0	True	3.97
213774	255908	KMLI	NaN	NaN	AGL	300.0	1	2020	41.448530	NaN	-90.507540	ENY	Climb	None	27	Overcast	135.0	IL	09:59	Day	Unknown	A	3.0	True	2.15

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters